SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwerelevamientoconstrucciones
AS
SELECT     Id, idCui, construccion, calle, numero, referencia, anioMayorParteConstruccion, idConstOrig, observaciones, idTipoEstr, idEstadoTipoEstr, 
                      idTipoTechoEstr, idEstadoTechoEstr, idTipoTechoCub, idEstadoTechoCub, idTipoParedMaterial, idEstadoParedMaterial, idTipoParedTerm, 
                      idEstadoParedTerm, subsuelo, plantaalta, totalPlantas, plantabaja, supCubierta, supCubierta_us_administ, supSemicubierta, 
                      supSemicubierta_us_administ, superficieTotal, F2completo, superficieTotal_us_administ, idServicioComedor, idRtaServicioComedorA, 
                      idRtaServicioComedorB, idRtaServicioComedorC, idRtaServicioComedorD, idRtaServicioComedorE, IdRtaTabElecGen, IdRtaProtecTabElecGen, 
                      IdRtaPTierTabElecGen, IdRtaTabElecSec, IdRtaLlaveTabElecSec, IdRtaPTierTabElecSec, [3_1_1_IdEstRedPub], [3_1_2_IdEstBomManual], 
                      IdRtaProtecTabElecSec, IdRtaLlaveTabElecGen, [3_1_3_IdEstBomAuto], [3_1_4_IdEstPluvial], [3_1_5_IdEstMolino], [3_1_6_IdEstMananVert], 
                      [3_1_7_IdEstCamCister], [3_1_8_IdEstCedida], [3_1_9_IdEstEnvasada], [3_1_10_IdEstOtro], [3_2_1_IdEstAljibe], [3_2_2_IdEstCisterna], 
                      [3_2_3_IdEstTanqElev], [3_2_4_IdEstTorrTanq], [3_2_6_IdEstOtro], [3_3_1_IdEstAbastBanos], [3_3_2_IdEstAbastCocina], [3_2_5_IdEstBidonBot], 
                      [3_3_3_IdEstAguaIncendio], [3_3_4_IdEstServRiego], [3_4_1_IdEstTratPotab], [3_4_1_IdRtaTratPotab], [3_4_2_ContSanitCant], [4_1_IdEstRedPub], 
                      [4_2_IdEstPlantTrat], [3_4_2_IdEstContSanit], [4_3_IdEstCamPozo], [4_4_IdEstPozoAbs], [4_5_IdEstLetrina], [4_6_IdEstOtroSist], [5_1_IdEstRedPub], 
                      [5_2_IdEstZepelin], [5_5_IdEstLenaCarb], [5_6_IdEstOtro], [6_1_1_IdEstRedPub], [5_3_IdEstGasTubo], [5_4_IdEstGasGarraf], [6_1_2_IdEstGrupElect], 
                      [6_1_2_GrupElectPotenc], [6_1_2_IdRtaGrupElectComb], [6_1_3_IdEstPanFotov], [6_1_3_PanFotovPotenc], [6_1_3_IdRtaPanFotovBater], 
                      [6_1_4_GenEolicPotenc], [6_1_4_IdEstGenEolicBater], [6_1_4_IdEstGenEolic], [6_1_5_IdEstOtro], [7_1_IdEstSistDetec], [7_2_IdEstInstCent], 
                      [7_2_InstCentCantBocas], [7_3_IdEstMatafA], [7_3_MatafACant], [7_3_IdRtaMatafACarga], [7_4_IdEstMatafABC], [7_4_MatafABCCant], 
                      [7_4_IdRtaMatafABCCarga], [7_5_IdEstMatafABCHalog], [7_5_MatafABCHalogCant], [7_5_IdRtaMatafABCHalogCarga], [7_6_IdEstMatafBC], 
                      [7_6_MatafBCCant], [7_6_IdRtaMatafBCCarga], [7_7_IdEstSalEmerg], [7_7_SalEmergCant], [7_8_IdRtaBarralAntip], [7_9_IdEstLuzEmerg], 
                      [7_10_IdEstPlanoEvac], [7_10_IdEstSimulEvac], [7_11_IdEstEscalExt], [7_12_IdEstSenaliz], [7_13_IdEstAlarmaRob], [7_14_IdEstAlarmaCatast], 
                      [7_15_IdEstVidSeg], [7_16_IdEstOtro], [8_1_IdEstAcens], [8_1_AcensCant], [8_1_IdRtaAcensManten], [8_2_IdEstMontCargEsc], [8_2_MontCargEscCant],
                       [8_2_IdRtaMontCarManten], [8_3_IdEstSanitDisc], [8_3_SanitDiscCant], [8_4_IdEstRampas], [8_5_IdEstSenLumi], [8_6_IdEstSenSonor], 
                      [8_7_IdEstPisoCiego], [8_8_IdEstParedCiego], [8_9_IdEstOtro]
FROM         dbo.u_f2_00_varios
GO
GRANT SELECT ON  [dbo].[vwerelevamientoconstrucciones] TO [Cenie]
GRANT INSERT ON  [dbo].[vwerelevamientoconstrucciones] TO [Cenie]
GRANT UPDATE ON  [dbo].[vwerelevamientoconstrucciones] TO [Cenie]
GO
